Dataset info
| Number of variables | 15 |
|---|---|
| Number of observations | 6970188 |
| Missing cells | 572 (< 0.1%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 797.7 MiB |
| Average record size in memory | 120.0 B |
Variables types
| Numeric | 9 |
|---|---|
| Categorical | 4 |
| Boolean | 0 |
| Date | 2 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 0 |
| Unsupported | 0 |
Warnings
end_station_name has a high cardinality: 844 distinct values | Warning |
start_station_name has a high cardinality: 816 distinct values | Warning |
tripduration is highly skewed (γ1 = 141.1379796) | Skewed |
bikeid
Numeric
| Distinct count | 16723 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 29957.97137 |
|---|---|
| Minimum | 14529 |
| Maximum | 42046 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 14529 |
|---|---|
| 5-th percentile | 16074 |
| Q1 | 25266 |
| Median | 31084 |
| Q3 | 38104 |
| 95-th percentile | 39887 |
| Maximum | 42046 |
| Range | 27517 |
| Interquartile range | 12838 |
Descriptive statistics
| Standard deviation | 7826.82986 |
|---|---|
| Coef of variation | 0.2612603425 |
| Kurtosis | -0.9793679575 |
| Mean | 29957.97137 |
| MAD | 6544.343449 |
| Skewness | -0.409496926 |
| Sum | 2.088126925e+11 |
| Variance | 61259265.66 |
| Memory size | 53.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[14529. 14529.5 14530.5 14532. 14534.5 ... 42033.5 42040.5 42044.5 42045.5 42046. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 33861 | 1135 | < 0.1% | |
| 39098 | 1134 | < 0.1% | |
| 39084 | 1131 | < 0.1% | |
| 39861 | 1129 | < 0.1% | |
| 39341 | 1127 | < 0.1% | |
| 39726 | 1114 | < 0.1% | |
| 38427 | 1114 | < 0.1% | |
| 38635 | 1111 | < 0.1% | |
| 39652 | 1110 | < 0.1% | |
| 39778 | 1108 | < 0.1% | |
| Other values (16713) | 6958975 | 99.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 14529 | 262 | < 0.1% | |
| 14530 | 342 | < 0.1% | |
| 14531 | 152 | < 0.1% | |
| 14533 | 404 | < 0.1% | |
| 14534 | 264 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 42046 | 86 | < 0.1% | |
| 42045 | 90 | < 0.1% | |
| 42044 | 99 | < 0.1% | |
| 42041 | 63 | < 0.1% | |
| 42040 | 117 | < 0.1% |
birth_year
Numeric
| Distinct count | 109 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1980.800941 |
|---|---|
| Minimum | 1874 |
| Maximum | 2003 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1874 |
|---|---|
| 5-th percentile | 1960 |
| Q1 | 1970 |
| Median | 1984 |
| Q3 | 1990 |
| 95-th percentile | 1996 |
| Maximum | 2003 |
| Range | 129 |
| Interquartile range | 20 |
Descriptive statistics
| Standard deviation | 12.02465784 |
|---|---|
| Coef of variation | 0.006070603861 |
| Kurtosis | 0.5764745763 |
| Mean | 1980.800941 |
| MAD | 10.11970796 |
| Skewness | -0.7043270065 |
| Sum | 1.380655495e+10 |
| Variance | 144.5923962 |
| Memory size | 53.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[1874. 1879.5 1885.5 1887.5 1889.5 ... 1999.5 2000.5 2001.5 2002.5 2003. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1969 | 667980 | 9.6% | |
| 1989 | 301287 | 4.3% | |
| 1990 | 297921 | 4.3% | |
| 1991 | 287167 | 4.1% | |
| 1992 | 283375 | 4.1% | |
| 1988 | 273993 | 3.9% | |
| 1993 | 263187 | 3.8% | |
| 1987 | 247136 | 3.5% | |
| 1994 | 241503 | 3.5% | |
| 1986 | 230953 | 3.3% | |
| Other values (99) | 3875686 | 55.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1874 | 2 | < 0.1% | |
| 1885 | 141 | < 0.1% | |
| 1886 | 62 | < 0.1% | |
| 1887 | 47 | < 0.1% | |
| 1888 | 344 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2003 | 4493 | 0.1% | |
| 2002 | 11003 | 0.2% | |
| 2001 | 23980 | 0.3% | |
| 2000 | 49606 | 0.7% | |
| 1999 | 60118 | 0.9% |
end_station_id
Numeric
| Distinct count | 844 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 143 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1661.57983 |
|---|---|
| Minimum | 72 |
| Maximum | 3858 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 72 |
|---|---|
| 5-th percentile | 217 |
| Q1 | 379 |
| Median | 509 |
| Q3 | 3298 |
| 95-th percentile | 3708 |
| Maximum | 3858 |
| Range | 3786 |
| Interquartile range | 2919 |
Descriptive statistics
| Standard deviation | 1480.240597 |
|---|---|
| Coef of variation | 0.8908633642 |
| Kurtosis | -1.820729113 |
| Mean | 1661.57983 |
| MAD | 1445.235024 |
| Skewness | 0.3195971179 |
| Sum | 1.158128619e+10 |
| Variance | 2191112.226 |
| Memory size | 53.2 MiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 519 | 49324 | 0.7% | |
| 426 | 44585 | 0.6% | |
| 497 | 42789 | 0.6% | |
| 514 | 40760 | 0.6% | |
| 3255 | 39215 | 0.6% | |
| 402 | 38392 | 0.6% | |
| 285 | 38281 | 0.5% | |
| 435 | 37245 | 0.5% | |
| 358 | 37188 | 0.5% | |
| 499 | 34842 | 0.5% | |
| Other values (833) | 6567424 | 94.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 72 | 16334 | 0.2% | |
| 79 | 8987 | 0.1% | |
| 82 | 4994 | 0.1% | |
| 83 | 6384 | 0.1% | |
| 116 | 25238 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3858 | 50 | < 0.1% | |
| 3854 | 28 | < 0.1% | |
| 3853 | 54 | < 0.1% | |
| 3842 | 179 | < 0.1% | |
| 3823 | 120 | < 0.1% |
end_station_latitude
Numeric
| Distinct count | 854 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 40.73683686 |
|---|---|
| Minimum | 40.65539977 |
| Maximum | 40.869 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 40.65539977 |
|---|---|
| 5-th percentile | 40.68323865 |
| Q1 | 40.71739973 |
| Median | 40.73652889 |
| Q3 | 40.7569332 |
| 95-th percentile | 40.789622 |
| Maximum | 40.869 |
| Range | 0.2136002255 |
| Interquartile range | 0.03953347 |
Descriptive statistics
| Standard deviation | 0.03039305734 |
|---|---|
| Coef of variation | 0.0007460828989 |
| Kurtosis | -0.2437232879 |
| Mean | 40.73683686 |
| MAD | 0.02427299606 |
| Skewness | 0.006798985266 |
| Sum | 283943411.4 |
| Variance | 0.0009237379342 |
| Memory size | 53.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[40.65539977 40.65624422 40.65907602 40.66188464 40.6628839 ... 40.82819722 40.8435 40.8615 40.8645 40.869 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 40.751873 | 49324 | 0.7% | |
| 40.71754834 | 44585 | 0.6% | |
| 40.73704984 | 42789 | 0.6% | |
| 40.76087502 | 40760 | 0.6% | |
| 40.75058535 | 39215 | 0.6% | |
| 40.7403432 | 38392 | 0.6% | |
| 40.73454567 | 38281 | 0.5% | |
| 40.74173969 | 37245 | 0.5% | |
| 40.73291553 | 37188 | 0.5% | |
| 40.76915505 | 34842 | 0.5% | |
| Other values (844) | 6567567 | 94.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 40.65539977 | 1048 | < 0.1% | |
| 40.65708867 | 1972 | < 0.1% | |
| 40.66106337 | 10962 | 0.2% | |
| 40.6627059 | 1354 | < 0.1% | |
| 40.6630619 | 2144 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 40.869 | 3 | < 0.1% | |
| 40.866 | 11 | < 0.1% | |
| 40.863 | 39 | < 0.1% | |
| 40.86 | 20 | < 0.1% | |
| 40.857 | 13 | < 0.1% |
end_station_longitude
Numeric
| Distinct count | 857 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -73.9821398 |
|---|---|
| Minimum | -74.0836394 |
| Maximum | -73.878 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -74.0836394 |
|---|---|
| 5-th percentile | -74.01020234 |
| Q1 | -73.99612349 |
| Median | -73.98602213 |
| Q3 | -73.971211 |
| 95-th percentile | -73.9441232 |
| Maximum | -73.878 |
| Range | 0.2056394 |
| Interquartile range | 0.02491249 |
Descriptive statistics
| Standard deviation | 0.02038046102 |
|---|---|
| Coef of variation | -0.0002754781232 |
| Kurtosis | 0.2993228203 |
| Mean | -73.9821398 |
| MAD | 0.01607361205 |
| Skewness | 0.75347269 |
| Sum | -515669423.1 |
| Variance | 0.0004153631915 |
| Memory size | 53.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-74.0836394 -74.05138932 -74.0287307 -74.02124382 -74.01705022 ... -73.9078718 -73.9063718 -73.8975 -73.8885 -73.878 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -73.977706 | 49324 | 0.7% | |
| -74.01322069 | 44585 | 0.6% | |
| -73.99009296 | 42789 | 0.6% | |
| -74.00277668 | 40760 | 0.6% | |
| -73.99468482 | 39215 | 0.6% | |
| -73.98955109 | 38392 | 0.6% | |
| -73.99074142 | 38281 | 0.5% | |
| -73.99415556 | 37245 | 0.5% | |
| -74.00711384 | 37188 | 0.5% | |
| -73.98191841 | 34842 | 0.5% | |
| Other values (847) | 6567567 | 94.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -74.0836394 | 1 | < 0.1% | |
| -74.06860113 | 1 | < 0.1% | |
| -74.06391263 | 1 | < 0.1% | |
| -74.0575736 | 1 | < 0.1% | |
| -74.0557013 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -73.878 | 2 | < 0.1% | |
| -73.881 | 5 | < 0.1% | |
| -73.884 | 11 | < 0.1% | |
| -73.887 | 12 | < 0.1% | |
| -73.89 | 33 | < 0.1% |
end_station_name
Categorical
| Distinct count | 844 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 143 |
| Pershing Square North | 49324 |
|---|---|
| West St & Chambers St | 44585 |
| E 17 St & Broadway | 42789 |
| Other values (840) |
| Value | Count | Frequency (%) | |
| Pershing Square North | 49324 | 0.7% | |
| West St & Chambers St | 44585 | 0.6% | |
| E 17 St & Broadway | 42789 | 0.6% | |
| 12 Ave & W 40 St | 40760 | 0.6% | |
| 8 Ave & W 31 St | 39215 | 0.6% | |
| Broadway & E 22 St | 38392 | 0.6% | |
| Broadway & E 14 St | 38281 | 0.5% | |
| W 21 St & 6 Ave | 37245 | 0.5% | |
| Christopher St & Greenwich St | 37188 | 0.5% | |
| Broadway & W 60 St | 34842 | 0.5% | |
| Other values (833) | 6567424 | 94.2% |
| Max length | 45 |
|---|---|
| Mean length | 19.68784802 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
gender
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 2 | |
| 0 | 627535 |
| Value | Count | Frequency (%) | |
| 1 | 4583435 | 65.8% | |
| 2 | 1759218 | 25.2% | |
| 0 | 627535 | 9.0% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
start_station_id
Numeric
| Distinct count | 817 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 143 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1667.021904 |
|---|---|
| Minimum | 72 |
| Maximum | 3858 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 72 |
|---|---|
| 5-th percentile | 223 |
| Q1 | 380 |
| Median | 514 |
| Q3 | 3295 |
| 95-th percentile | 3708 |
| Maximum | 3858 |
| Range | 3786 |
| Interquartile range | 2915 |
Descriptive statistics
| Standard deviation | 1479.962518 |
|---|---|
| Coef of variation | 0.8877882857 |
| Kurtosis | -1.825216948 |
| Mean | 1667.021904 |
| MAD | 1445.574209 |
| Skewness | 0.3117376437 |
| Sum | 1.161921768e+10 |
| Variance | 2190289.055 |
| Memory size | 53.2 MiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 519 | 49881 | 0.7% | |
| 497 | 41456 | 0.6% | |
| 426 | 41150 | 0.6% | |
| 514 | 39577 | 0.6% | |
| 3255 | 39034 | 0.6% | |
| 285 | 38174 | 0.5% | |
| 435 | 37237 | 0.5% | |
| 358 | 37020 | 0.5% | |
| 402 | 35797 | 0.5% | |
| 499 | 35620 | 0.5% | |
| Other values (806) | 6575099 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 72 | 16549 | 0.2% | |
| 79 | 8946 | 0.1% | |
| 82 | 4939 | 0.1% | |
| 83 | 6303 | 0.1% | |
| 116 | 25080 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3858 | 45 | < 0.1% | |
| 3854 | 26 | < 0.1% | |
| 3853 | 42 | < 0.1% | |
| 3842 | 163 | < 0.1% | |
| 3823 | 111 | < 0.1% |
start_station_latitude
Numeric
| Distinct count | 827 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 40.73720431 |
|---|---|
| Minimum | 40.65539977 |
| Maximum | 40.869 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 40.65539977 |
|---|---|
| 5-th percentile | 40.68382604 |
| Q1 | 40.71745169 |
| Median | 40.73704984 |
| Q3 | 40.75742 |
| 95-th percentile | 40.79017948 |
| Maximum | 40.869 |
| Range | 0.2136002255 |
| Interquartile range | 0.03996831 |
Descriptive statistics
| Standard deviation | 0.03046121841 |
|---|---|
| Coef of variation | 0.000747749359 |
| Kurtosis | -0.2577367091 |
| Mean | 40.73720431 |
| MAD | 0.02434459789 |
| Skewness | -0.01004473518 |
| Sum | 283945972.6 |
| Variance | 0.000927885827 |
| Memory size | 53.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[40.65539977 40.65624422 40.65907602 40.66188464 40.6628839 ... 40.81436002 40.82819722 40.8435 40.8525 40.869 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 40.751873 | 49881 | 0.7% | |
| 40.73704984 | 41456 | 0.6% | |
| 40.71754834 | 41150 | 0.6% | |
| 40.76087502 | 39577 | 0.6% | |
| 40.75058535 | 39034 | 0.6% | |
| 40.73454567 | 38174 | 0.5% | |
| 40.74173969 | 37237 | 0.5% | |
| 40.73291553 | 37020 | 0.5% | |
| 40.7403432 | 35797 | 0.5% | |
| 40.76915505 | 35620 | 0.5% | |
| Other values (817) | 6575242 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 40.65539977 | 1018 | < 0.1% | |
| 40.65708867 | 1840 | < 0.1% | |
| 40.66106337 | 10890 | 0.2% | |
| 40.6627059 | 1352 | < 0.1% | |
| 40.6630619 | 2124 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 40.869 | 3 | < 0.1% | |
| 40.866 | 14 | < 0.1% | |
| 40.863 | 33 | < 0.1% | |
| 40.86 | 25 | < 0.1% | |
| 40.857 | 14 | < 0.1% |
start_station_longitude
Numeric
| Distinct count | 830 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -73.98197953 |
|---|---|
| Minimum | -74.02535319 |
| Maximum | -73.878 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -74.02535319 |
|---|---|
| 5-th percentile | -74.00965965 |
| Q1 | -73.99596 |
| Median | -73.98564945 |
| Q3 | -73.97114574 |
| 95-th percentile | -73.9441232 |
| Maximum | -73.878 |
| Range | 0.1473531933 |
| Interquartile range | 0.0248142561 |
Descriptive statistics
| Standard deviation | 0.02028133593 |
|---|---|
| Coef of variation | -0.0002741388654 |
| Kurtosis | 0.3169214013 |
| Mean | -73.98197953 |
| MAD | 0.01597455322 |
| Skewness | 0.7492888395 |
| Sum | -515668305.9 |
| Variance | 0.000411332587 |
| Memory size | 53.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-74.02535319 -74.02124382 -74.01705022 -74.01687143 -74.01668019 ... -73.9078718 -73.9063718 -73.8945 -73.8885 -73.878 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -73.977706 | 49881 | 0.7% | |
| -73.99009296 | 41456 | 0.6% | |
| -74.01322069 | 41150 | 0.6% | |
| -74.00277668 | 39577 | 0.6% | |
| -73.99468482 | 39034 | 0.6% | |
| -73.99074142 | 38174 | 0.5% | |
| -73.99415556 | 37237 | 0.5% | |
| -74.00711384 | 37020 | 0.5% | |
| -73.98955109 | 35797 | 0.5% | |
| -73.98191841 | 35620 | 0.5% | |
| Other values (820) | 6575242 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -74.02535319 | 5022 | 0.1% | |
| -74.01713445 | 15872 | 0.2% | |
| -74.016966 | 6245 | 0.1% | |
| -74.01677685 | 20583 | 0.3% | |
| -74.01658354 | 26797 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -73.878 | 2 | < 0.1% | |
| -73.881 | 5 | < 0.1% | |
| -73.884 | 9 | < 0.1% | |
| -73.887 | 10 | < 0.1% | |
| -73.89 | 38 | < 0.1% |
start_station_name
Categorical
| Distinct count | 816 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 143 |
| Pershing Square North | 49881 |
|---|---|
| E 17 St & Broadway | 41456 |
| West St & Chambers St | 41150 |
| Other values (812) |
| Value | Count | Frequency (%) | |
| Pershing Square North | 49881 | 0.7% | |
| E 17 St & Broadway | 41456 | 0.6% | |
| West St & Chambers St | 41150 | 0.6% | |
| 12 Ave & W 40 St | 39577 | 0.6% | |
| 8 Ave & W 31 St | 39034 | 0.6% | |
| Broadway & E 14 St | 38174 | 0.5% | |
| W 21 St & 6 Ave | 37237 | 0.5% | |
| Christopher St & Greenwich St | 37020 | 0.5% | |
| Broadway & E 22 St | 35797 | 0.5% | |
| Broadway & W 60 St | 35620 | 0.5% | |
| Other values (805) | 6575099 | 94.3% |
| Max length | 45 |
|---|---|
| Mean length | 19.69565713 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
starttime
Date
| Distinct count | 6965264 |
|---|---|
| Unique (%) | 99.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2019-07-01 00:00:00.132000 |
|---|---|
| Maximum | 2019-09-30 23:59:55.374000 |
Histogram of 'starttime' (bins=N)
stoptime
Date
| Distinct count | 6965148 |
|---|---|
| Unique (%) | 99.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2019-07-01 00:01:59.606000 |
|---|---|
| Maximum | 2019-10-11 15:16:53.307000 |
Histogram of 'stoptime' (bins=N)
tripduration
Numeric
| Distinct count | 19849 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1032.187276 |
|---|---|
| Minimum | 61 |
| Maximum | 3812666 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 61 |
|---|---|
| 5-th percentile | 182 |
| Q1 | 389 |
| Median | 667 |
| Q3 | 1166 |
| 95-th percentile | 2190 |
| Maximum | 3812666 |
| Range | 3812605 |
| Interquartile range | 777 |
Descriptive statistics
| Standard deviation | 10833.8484 |
|---|---|
| Coef of variation | 10.49601041 |
| Kurtosis | 25559.1308 |
| Mean | 1032.187276 |
| MAD | 722.3758361 |
| Skewness | 141.1379796 |
| Sum | 7194539367 |
| Variance | 117372271.1 |
| Memory size | 53.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[6.1000000e+01 6.1500000e+01 6.8500000e+01 7.7500000e+01 8.1500000e+01 ... 5.4095800e+05 8.8923650e+05 1.5510605e+06 2.6893220e+06 3.8126660e+06], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 332 | 7548 | 0.1% | |
| 379 | 7541 | 0.1% | |
| 361 | 7522 | 0.1% | |
| 315 | 7517 | 0.1% | |
| 374 | 7497 | 0.1% | |
| 353 | 7468 | 0.1% | |
| 319 | 7462 | 0.1% | |
| 357 | 7460 | 0.1% | |
| 346 | 7458 | 0.1% | |
| 336 | 7457 | 0.1% | |
| Other values (19839) | 6895258 | 98.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 61 | 969 | < 0.1% | |
| 62 | 995 | < 0.1% | |
| 63 | 1026 | < 0.1% | |
| 64 | 1004 | < 0.1% | |
| 65 | 1035 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3812666 | 1 | < 0.1% | |
| 3341929 | 1 | < 0.1% | |
| 2904620 | 1 | < 0.1% | |
| 2704549 | 1 | < 0.1% | |
| 2674095 | 1 | < 0.1% |
usertype
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Subscriber | |
|---|---|
| Customer |
| Value | Count | Frequency (%) | |
| Subscriber | 5713907 | 82.0% | |
| Customer | 1256281 | 18.0% |
| Max length | 10 |
|---|---|
| Mean length | 9.63952737 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
First rows
| bikeid | birth_year | end_station_id | end_station_latitude | end_station_longitude | end_station_name | gender | start_station_id | start_station_latitude | start_station_longitude | start_station_name | starttime | stoptime | tripduration | usertype | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 35305 | 1996 | 408.0 | 40.710762 | -73.994004 | Market St & Cherry St | 2 | 531.0 | 40.718939 | -73.992663 | Forsyth St & Broome St | 2019-08-01 00:00:01.468 | 2019-08-01 00:06:35.378 | 393 | Subscriber |
| 1 | 38822 | 1998 | 3409.0 | 40.686744 | -73.990632 | Bergen St & Smith St | 2 | 274.0 | 40.686919 | -73.976682 | Lafayette Ave & Fort Greene Pl | 2019-08-01 00:00:01.929 | 2019-08-01 00:10:29.784 | 627 | Subscriber |
| 2 | 18373 | 1988 | 3388.0 | 40.682800 | -73.999904 | President St & Henry St | 1 | 2000.0 | 40.702551 | -73.989402 | Front St & Washington St | 2019-08-01 00:00:04.048 | 2019-08-01 00:18:56.165 | 1132 | Subscriber |
| 3 | 25002 | 1988 | 473.0 | 40.721101 | -73.991925 | Rivington St & Chrystie St | 1 | 479.0 | 40.760193 | -73.991255 | 9 Ave & W 45 St | 2019-08-01 00:00:04.163 | 2019-08-01 00:29:44.794 | 1780 | Subscriber |
| 4 | 31198 | 1965 | 3312.0 | 40.781721 | -73.945940 | 1 Ave & E 94 St | 2 | 3312.0 | 40.781721 | -73.945940 | 1 Ave & E 94 St | 2019-08-01 00:00:05.458 | 2019-08-01 00:25:23.455 | 1517 | Subscriber |
| 5 | 21628 | 1998 | 3707.0 | 40.741459 | -73.983293 | Lexington Ave & E 26 St | 1 | 173.0 | 40.760683 | -73.984527 | Broadway & W 49 St | 2019-08-01 00:00:11.806 | 2019-08-01 00:10:43.959 | 632 | Subscriber |
| 6 | 25914 | 1995 | 326.0 | 40.729538 | -73.984267 | E 11 St & 1 Ave | 1 | 3718.0 | 40.727464 | -73.979504 | E 11 St & Avenue B | 2019-08-01 00:00:18.201 | 2019-08-01 00:02:15.860 | 117 | Subscriber |
| 7 | 34414 | 1999 | 3724.0 | 40.766741 | -73.979069 | 7 Ave & Central Park South | 1 | 493.0 | 40.756800 | -73.982912 | W 45 St & 6 Ave | 2019-08-01 00:00:22.084 | 2019-08-01 00:06:40.935 | 378 | Subscriber |
| 8 | 28226 | 1992 | 3232.0 | 40.689622 | -73.983043 | Bond St & Fulton St | 1 | 355.0 | 40.716021 | -73.999744 | Bayard St & Baxter St | 2019-08-01 00:00:22.087 | 2019-08-01 00:18:44.389 | 1102 | Subscriber |
| 9 | 33448 | 1968 | 469.0 | 40.763441 | -73.982681 | Broadway & W 53 St | 1 | 513.0 | 40.768254 | -73.988639 | W 56 St & 10 Ave | 2019-08-01 00:00:22.558 | 2019-08-01 00:29:15.908 | 1733 | Customer |
Last rows
| bikeid | birth_year | end_station_id | end_station_latitude | end_station_longitude | end_station_name | gender | start_station_id | start_station_latitude | start_station_longitude | start_station_name | starttime | stoptime | tripduration | usertype | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6970178 | 38760 | 1993 | 472.0 | 40.745712 | -73.981948 | E 32 St & Park Ave | 1 | 2003.0 | 40.733812 | -73.980544 | 1 Ave & E 18 St | 2019-09-30 23:58:27.320 | 2019-10-01 00:09:00.139 | 632 | Customer |
| 6970179 | 32452 | 1969 | 3716.0 | 40.753599 | -73.937956 | 40 Ave & Crescent St | 0 | 3105.0 | 40.724055 | -73.955736 | N 15 St & Wythe Ave | 2019-09-30 23:58:33.391 | 2019-10-01 00:24:16.433 | 1543 | Customer |
| 6970180 | 14819 | 1983 | 244.0 | 40.691960 | -73.965369 | Willoughby Ave & Hall St | 1 | 2021.0 | 40.759291 | -73.988597 | W 45 St & 8 Ave | 2019-09-30 23:58:56.478 | 2019-10-01 00:52:11.874 | 3195 | Subscriber |
| 6970181 | 19483 | 1969 | 224.0 | 40.711464 | -74.005524 | Spruce St & Nassau St | 0 | 296.0 | 40.714131 | -73.997047 | Division St & Bowery | 2019-09-30 23:59:02.420 | 2019-10-01 00:14:56.611 | 954 | Customer |
| 6970182 | 26456 | 1995 | 3686.0 | 40.739448 | -74.005070 | Gansevoort St & Hudson St | 1 | 369.0 | 40.732241 | -74.000264 | Washington Pl & 6 Ave | 2019-09-30 23:59:04.283 | 2019-10-01 00:04:08.806 | 304 | Subscriber |
| 6970183 | 41516 | 1995 | 3161.0 | 40.780184 | -73.977285 | W 76 St & Columbus Ave | 1 | 3314.0 | 40.793770 | -73.971888 | W 95 St & Broadway | 2019-09-30 23:59:22.767 | 2019-10-01 00:28:47.318 | 1764 | Customer |
| 6970184 | 31124 | 1959 | 327.0 | 40.715338 | -74.016584 | Vesey Pl & River Terrace | 2 | 316.0 | 40.709560 | -74.006536 | Fulton St & William St | 2019-09-30 23:59:27.927 | 2019-10-01 00:05:46.570 | 378 | Subscriber |
| 6970185 | 30285 | 1998 | 393.0 | 40.722992 | -73.979955 | E 5 St & Avenue C | 1 | 3260.0 | 40.727064 | -73.996621 | Mercer St & Bleecker St | 2019-09-30 23:59:29.145 | 2019-10-01 00:08:50.807 | 561 | Customer |
| 6970186 | 38290 | 1989 | 3435.0 | 40.718822 | -73.995960 | Grand St & Elizabeth St | 1 | 3746.0 | 40.724308 | -74.004730 | 6 Ave & Broome St | 2019-09-30 23:59:42.252 | 2019-10-01 00:04:54.232 | 311 | Subscriber |
| 6970187 | 34013 | 1969 | 2012.0 | 40.739445 | -73.976806 | E 27 St & 1 Ave | 0 | 331.0 | 40.711731 | -73.991930 | Pike St & Monroe St | 2019-09-30 23:59:55.374 | 2019-10-01 00:24:55.840 | 1500 | Customer |